﻿IF object_id(N'dbo.UDS_Bbs_ForumItem', 'U') IS NULL
BEGIN
    CREATE TABLE [dbo].[UDS_Bbs_ForumItem] (
        [item_id]          int           NOT NULL identity(1, 1),
        [board_id]         int           NULL,
        [title]            nvarchar(300)  COLLATE Chinese_PRC_CI_AS NULL,
        [content]          nvarchar(max) COLLATE Chinese_PRC_CI_AS NULL,
        [sender]           nvarchar(50)   COLLATE Chinese_PRC_CI_AS NULL,
        [send_time]        datetime      NULL,
        [hit_times]        int           NULL CONSTRAINT [DF_UDS_Bbs_ForumItem_hit_times] default(((0))),
        [replay_times]     int           NULL CONSTRAINT [DF_UDS_Bbs_ForumItem_replay_times] default(((0))),
        [last_replayer]    nvarchar(50)   COLLATE Chinese_PRC_CI_AS NULL,
        [last_replay_time] datetime      NULL,
        [ip]               nvarchar(50)   COLLATE Chinese_PRC_CI_AS NULL,
        [bulletin]         bit           NULL CONSTRAINT [DF_UDS_Bbs_ForumItem_bulletin] default(((0))),
        [sysbulletin]      bit           NULL CONSTRAINT [DF_UDS_Bbs_ForumItem_sysbulletin] default(((0))),
        [desktop]          bit           NULL CONSTRAINT [DF_UDS_Bbs_ForumItem_desktop] default(((0))),

        CONSTRAINT [PK_uds_bbs_forumItem] PRIMARY KEY CLUSTERED ([item_id] asc)
    );
END
GO
